How to: Find notes in a worksheet.
Solution:
Select 'Find...' from the 'Edit' menu to display the 'Find' dialog box. Type the note to be found in the 'Find What' box. Select 'Notes' from the 'Look in' drop-down list and other options as appropriate. Click 'Find Next'.
1) Select the 'Edit' menu and select 'Find...'. (The Find dialog box appears.)
2) Type the note to be found in the 'Find What' box.
NOTE: If the exact note is unknown, use question marks (?) or asterisks (*). Question marks and asterisks are wildcard characters. A question mark is used to represent any single character while an asterisk is used to represent any number of characters. If searching for a question mark or asterisk, precede these characters with a tilde (~).
EXAMPLE: To search for a note that starts with the word 'Formula', type 'Formula*' in the 'Find What box.
3) (Optional) Select 'By Rows' or 'By Columns' from the 'Search' drop-down list.
NOTE: Excel selects 'By Rows' automatically.
4) Select 'Notes' from the 'Look in' drop-down list.
5) (Optional) Select the 'Match Case' check box to find characters with cases that match exactly those typed in the 'Find What' box.
Finding a note
6) (Optional) Select the 'Find Entire Cells Only' check box to find exact and complete matches only.
7) Click 'Find Next'.
8) Click 'Close' when the note is found.
